Debbie Sawyer Community Champion

Overview

Overview

Email	debbie.sawyer@smarterbusinessprocesses.com
Roles	Member
Badges	41

About Me

About Me

Area of Expertise	Smartsheet; Process Modelling; Relational Data Models; Applications Training & Smartsheet Consultancy
About Me	I have been a Smartsheet Trainer and Consultant since October 2016. Prior to using Smartsheet I trained Microsoft Office applications including MS Excel, MS Access and MS Project, all relevant knowledge to use within my Smartsheet Consulting. Along with experience in utilising and teaching clients how to get the most from Smartsheet, I also consult in Business Process Mapping. If you can determine your business processes and define your workflows, then you can see where your IT toolset needs to interact with your processes and you will discover a more streamlined experience of using this amazing collaborative tool.<br /><br />debbie.sawyer@smarterbusinessprocesses.com
How I Use Smartsheet	I use Smartsheet daily to provide solutions to clients, these include Process Flow Tracker type sheets with Dashboards & Reports; Project Sheets & Project Management type Reports and Dashboards; Statistical type solutions using formulae driving charts; Survey type solutions with associated statistics and dashboards. I work with colleagues that also provide API solutions that take Smartsheet/Appsheet and other apps that little bit further. I provide Onsite Training in Smartsheet and also run remote Smartsheet Training session across Zoom.
Linkedin	https://www.linkedin.com/in/debbiesawyer/

Analytics

741

Posts

864

Visits

2.4k

Points

Feb 28, 2019

Join Date

Mar 5, 2025

Last Active

Reactions

• Insightful 36

  36
• Vote Up 67

  67
• Awesome 93

  93

• Activity
• Discussions9
• Comments732

• Re: conditional formatting for dates in another column

  Debbie Sawyer

  05/23/23
  @Chasity Rather than try and explain in words here, I have created a very quick sample sheet of how you can get the right colours. Set up a helper column with an IF statement which would return the c…
  2 ·

• New Badge Idea - Project Management Certification

  Debbie Sawyer

  05/04/23
  Having reviews the badges area of the Community, there is only a badge celebrating the Core Certification exam. Please could we have badges to display for passing the Solutions Center Exam and the Pr…
  9 ·

• Re: Project Sheet -- Dependencies report

  Debbie Sawyer

  09/16/22
  Dear All I haven't seen a report capability for this yet, so I have put my thinking cap on and come up with this workaround? Will this help anyone? In this demo project sheet, I have created a column…
  1 ·

• Re: How Can I update certain cells in a another sheet when a row is added to original submission sheet?

  Debbie Sawyer

  03/06/23
  @Mohamed.muse Hi Mohamed - I hope you don't mind, but for the benefit of this community post thread, I thought I'd just summarise what we did on our zoom call so that people searching in the future c…
  1 ·

• Re: Automations after a status change

  Debbie Sawyer

  02/01/23
  @Lee Ackerman HI Lee, yes. You can set up a helper column as a checkbox that is driven by a nested IF function based on the date that status went on and the type of hold status. As soon as the durati…
  1 ·

Previous Next